MyDAC

TCustomDAConnection.ExecSQL Method

Executes a SQL statement with parameters.

Class

TCustomDAConnection

Syntax

function ExecSQL(const Text: string): variant; overload;function ExecSQL(const Text: string; const Params: array of variant): variant; overload; virtual;

Parameters
Text
a SQL statement to be executed.
Params
Array of parameter values arranged in the same order as they appear in SQL statement.
Return Value
Out parameter with the name Result will hold the result of function having data type dtString. Otherwise returns Null.

Remarks

Use the ExecSQL method to execute any SQL statement outside the TCustomDADataSet or TCustomDASQL components. Supply the Params array with the values of parameters arranged in the same order as they appear in a SQL statement which itself is passed to the Text string parameter.

Note: If a query doesn't have parameters (Params.Count = 0), this query will be executed faster.

See Also

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback